home *** CD-ROM | disk | FTP | other *** search
/ Belgian Amiga Club - ADF Collection / BS1 part 60.zip / BS1 part 60 / Prof. Calc d3.adf / Financial / Projected Income.PCF (.txt) < prev    next >
Gold Disk Spreadsheet  |  1991-12-11  |  7KB  |  152 lines
  1. Gadgets and Widgets INC
  2.   Projected Income Statement
  3. Sales Growth
  4. 25.00%
  5. 20.00%
  6. 333330
  7. 15.00%
  8. 10.00%
  9. Percentage of Sales
  10.   Cost of Goods sold
  11. 50.00%
  12. 50.00%
  13. 45.00%
  14. 45.00%
  15.   Rent
  16. 3.00%
  17. 3.00%
  18. 2.50%
  19. 2.50%
  20.   Depreciation
  21. 15000.00
  22. 15000.00
  23. 15000.00
  24. 18000.00
  25.   Utilities
  26. 2.75%
  27. 3.00%
  28. 3.00%
  29. 3.50%
  30.   General Expenses
  31. 5.50%
  32. 6.00%
  33. 6.00%
  34. 6.00%
  35.   Advertising
  36. 333330
  37. 7.50%
  38. 8.00%
  39. 9.00%
  40. 10.00%
  41. Dollar Amounts
  42.   Interest on existing Debt
  43. 18000
  44. 18000
  45. 18000
  46. 18000
  47.     Tax Rate
  48. 28.00%
  49. 333332
  50. 30.00%
  51. 333332
  52. 30.00%
  53. 333332
  54. 30.00%
  55. H ----------------------------------------------------------------------
  56.     Revenues
  57. 400000
  58. 500000
  59. 600000
  60. 690000
  61. 759000
  62.   Cost of Goods Sold
  63. 200000
  64. 250000
  65. 300000
  66. 310500
  67. 341550
  68. Gross Profit
  69. 200000
  70. 250000
  71. 300000
  72. 379500
  73. 417450
  74.  ----------
  75.   Rent
  76. 12000
  77. 15000
  78. 18000
  79. 17250
  80. 18975
  81.   Depreciation
  82. 15000
  83. 15000
  84. 15000
  85. 15000
  86. 18000
  87.   Utilities
  88. 11000
  89. 13750
  90. 18000
  91. 20700
  92. 26565
  93.   General Expenses
  94. 21000
  95. 27500
  96. 36000
  97. 41400
  98. 45540
  99.   Advertising
  100. 30000
  101. 37500
  102. 48000
  103. 62100
  104. 75900
  105.  ----------
  106.   Total Costs
  107. 89000
  108. 108750
  109. 135000
  110. 156450
  111. 184980
  112. Operating Profit
  113. 111000
  114. 141250
  115. 165000
  116. 223050
  117. 232470
  118.  ----------
  119.   Interest Expense
  120. 18000
  121. 18000
  122. 18000
  123. 18000
  124. 18000
  125. Taxable Profit
  126. 93000
  127. 123250
  128. 147000
  129. 205050
  130. 214470
  131.  ----------
  132.   Income Tax
  133. 19000
  134. 34510
  135. 44100
  136. 61515
  137. 64341
  138. After Tax Profit
  139. 74000
  140. 88740
  141. 102900
  142. 143535
  143. 150129
  144.   Dividends
  145.  ----------
  146. Retained Earnings
  147. 74000
  148. 88740
  149. 102900
  150. 143535
  151. 150129
  152.